Passwords in the db don't work in different deployment environments

Hi there,

I have been trying to use the same database for 2 Rails applications. I want to use the same data for both the apps including the authentication. But if I try to login using the credentials created in one app in the other app it doesn't work. I use restful_authentication for the logins. Though I have sessions also in the database I have no intention to share them between the applications.

In further tests I imported the production db into my local development db and set it up in my local computer just to see if authentication works provided the same username/password. But it doesn't work. Here I am using the same application code and pretty much everything in the production environment has been replicated.

My site_keys.rb and session_store.rb are same across the production/development environments and the 2 apps I mentioned earlier.

Have anybody faced this problem?

Thanks
-subbu